Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
GeophysicalLocationCoordinateID (PK) | Token identifier for a POINT location (a longitude, latitude, altitude coordinate). | ID_GEO_LCN_CRDN | Identity | integer | |
GeophysicalCoordinateSystemTypeCode (AK)(FK) | A retailer assigned mnemonic code denoting the geo-physical co-ordinate system. | CD_TYP_CRDN_GEO | Code2 | char(2) | GeophysicalCoordinateSystem(LO_CRDN_TYP) |
CoOrdinateValue (AK) | A string containing the Co-Ordinate, the format of which is defined by the GeoPhysicalCoOrdinateSystem. Eg: ISO-6709 defines a standardised representation of Latitude, Longitude & Altitude: �DDMMSS.SS�DDDMMSS.SS�AAAA.AA/ where: � = direction identitier DD & DDD = Degrees of latitude & longitude MM = Minutes of latitude & longitude SS.SS = Seconds of latitude & longitude AAAA.AA = metres of altitude / = terminator So the summit of Mt Everest is represented by +27.5916+086.5640+8850/ | CD_CRDN_VL | ISO-6709LongitudeLatitude | varchar(30) | |
LongitudeDegrees | Longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface. Degree is a unit of measure that appear as vertical lines that organize the Earth into 360 equal segments. | DGR_LNGTD | DegreeLongitude | integer | |
LongitudeMinutes | Longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface. Minute is a unit of measure that appear as vertical lines that organize each degree into 60 equal segments. | MI_LNGTD | MinuteSecond | integer | |
LongitudeSeconds | Longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface. Minute is a unit of measure that appear as vertical lines that organize each minute into 60 equal segments. | SI_LNGTD | MinuteSecond | integer | |
LongitudeDirectionCode | One of two values indicating corrdinate direction relative to the PRIME Meridian + = EAST of the PRIME Meridian - = WEST of the PRIME Meridian | CD_LNGTD_DIR | Code | char(1) | |
LatitudeDegrees | In geography, latitude (f) is a geographic coordinate that specifies the north-south position of a point on the Earth's surface. Degree organizes northern half of the Earth into 90 segments numberd as positive values and the sourthern half of the Earth into 90 segments numbered as negative values. | DGR_LTTD | DegreeLatitude | integer | |
LatitudeMinutes | In geography, latitude (f) is a geographic coordinate that specifies the north-south position of a point on the Earth's surface. Minute organizes a degree into 60 equal segments | MI_LTTD | MinuteSecond | integer | |
LatitudeSeconds | In geography, latitude (f) is a geographic coordinate that specifies the north-south position of a point on the Earth's surface. Second organizes a minute into 60 equal segments | SI_LTTD | MinuteSecond | integer | |
LatitudeDirectionCode | One of two values indicating corrdinate direction relative to the EQUATOR One of two signs + = north of the equator - = south of the equator | CD_LTTD_DRC | Code | char(1) | |
AltitudeMeters | Altitude measured in meters. A positive value is an altitude above sea level (0 meters). A negative value is altitude below sea level (e.g. Death Valley or the Dead Sea) | QU_ALTTD_MTR | Quantity | integer | |